Á¤º¸Ã³¸®ÇÐȸ ³í¹®Áö ¼ÒÇÁÆ®¿þ¾î ¹× µ¥ÀÌÅÍ °øÇÐ
Current Result Document :
ÇѱÛÁ¦¸ñ(Korean Title) |
µ¥ÀÌÅͺ£À̽º ¾ÐÃà ¼º´É Çâ»óÀ» À§ÇÑ ¼±ÅÃÀû ¾ÐÃà Àü·« |
¿µ¹®Á¦¸ñ(English Title) |
A Selective Compression Strategy for Performance Improvement of Database Compression |
ÀúÀÚ(Author) |
Ki-Hoon Lee
À̱âÈÆ
|
¿ø¹®¼ö·Ïó(Citation) |
VOL 04 NO. 09 PP. 0371 ~ 0376 (2015. 09) |
Çѱ۳»¿ë (Korean Abstract) |
»ç¹°ÀÎÅͳÝ(IoT)Àº µ¥ÀÌÅÍÀÇ ¾çÀ» »ó´çÈ÷ Áõ°¡½ÃŲ´Ù. µ¥ÀÌÅͺ£À̽º ¾ÐÃàÀº ÀúÀå ½Ã½ºÅÛ ºñ¿ë°ú I/O ´ë¿ªÆøÀ» Àý¾àÇÒ ¼ö Àֱ⠶§¹®¿¡ ºòµ¥ÀÌÅÍ¿¡ ÀÖ¾î¼ Áß¿äÇÏ´Ù. ±×·¯³ª µ¥ÀÌÅͺ£À̽º ¾ÐÃàÀº ¾ÐÃàµÈ ÆäÀÌÁö¿¡ ´ëÇÑ ¾÷µ¥ÀÌÆ®·Î ÀÎÇØ OLTP¿Í °°Àº ¾²±â ÁýÁßÀûÀÎ ¿öÅ©·Îµå¿¡ ´ëÇØ ³·Àº ¼º´ÉÀ» º¸ÀÏ ¼ö ÀÖ´Ù. º» ³í¹®¿¡¼´Â µ¥ÀÌÅͺ£À̽º ¾ÐÃàÀÇ ¼º´É Çâ»óÀ» À§ÇÑ ½Ç¿ëÀû °¡À̵å¶óÀÎÀ» Á¦½ÃÇÑ´Ù. ƯÈ÷, ¾ÐÃà ÆäÀÌÁö Å©±â¿¡ ÀÇÇÑ °è»êÀ¸·ÎºÎÅÍ ¿¹»óµÇ´Â °ø°£ Àý¾à°ú °ÅÀÇ °°Àº °ø°£ Àý¾àÀ» º¸ÀÌ´Â Å×À̺íµé¸¸À» ¾ÐÃàÇÏ´Â SELECTIVE Àü·«À» Á¦½ÃÇÑ´Ù. TPC-C º¥Ä¡¸¶Å©¿Í MySQLÀ» ÀÌ¿ëÇÑ ½ÇÇèÀ» ÅëÇØ SELECTIVE Àü·«ÀÌ ¾ÐÃàÇÏÁö ¾Ê´Â ¹æ¹ý¿¡ ºñÇØ 1.1¹è ³ôÀº ¼º´ÉÀ» º¸ÀÌ¸é¼ 17.3%ÀÇ °ø°£À» Àý¾àÇÑ´Ù´Â °ÍÀ» º¸¿´´Ù.
|
¿µ¹®³»¿ë (English Abstract) |
The Internet of Things (IoT) significantly increases the amount of data. Database compression is important for big data because it can reduce costs for storage systems and save I/O bandwidth. However, it could show low performance for write-intensive workloads such as OLTP due to the updates of compressed pages. In this paper, we present practical guidelines for the performance improvement of database compression. Especially, we propose the SELECTIVE strategy, which compresses only tables whose space savings are close to the expected space savings calculated by the compressed page size. Experimental results using the TPC-C benchmark and MySQL show that the strategy can achieve 1.1 times better performance than the uncompressed counterpart with 17.3% space savings.
|
Å°¿öµå(Keyword) |
Database Compression
Performance Improvement
OLTP
TPC-C
µ¥ÀÌÅͺ£À̽º¾ÐÃà
¼º´É Çâ»ó
OLTP
TPC-C
|
ÆÄÀÏ÷ºÎ |
PDF ´Ù¿î·Îµå
|